Overview

Dataset info

Number of variables37
Number of observations6673
Missing cells10945 (< 0.1%)
Duplicate rows0 (0.0%)
Total size in memory1.7 MiB
Average record size in memory261.0 B

Variables types

Numeric15
Categorical4
Boolean4
Date0
URL1
Text (Unique)0
Rejected13
Unsupported0

Warnings

accuracy has 2210 (33.1%) zeros Zeros
avg_rating is highly correlated with accuracy (ρ = 0.99232) Rejected
bedrooms has 446 (6.7%) zeros Zeros
checkin is highly correlated with avg_rating (ρ = 0.98906) Rejected
cleanliness is highly correlated with checkin (ρ = 0.98857) Rejected
communication is highly correlated with cleanliness (ρ = 0.98852) Rejected
currency has constant value "CAD" Rejected
guest_satisfication is highly correlated with communication (ρ = 0.99219) Rejected
host_reviews has 841 (12.6%) zeros Zeros
is_business_travel_ready has constant value "False" Rejected
listing_name has a high cardinality: 6587 distinct values Warning
localized_city has a high cardinality: 96 distinct values Warning
localized_neighborhood has constant value "nan" Rejected
location is highly correlated with guest_satisfication (ρ = 0.98793) Rejected
price is highly correlated with amt_w_service (ρ = 1) Rejected
rate_type has constant value "nightly" Rejected
response_rate has 1328 (19.9%) zeros Zeros
response_time has 1217 (18.2%) missing values Missing
reviews_count has 2089 (31.3%) zeros Zeros
star_rating is highly correlated with guest_satisfication (ρ = 0.91733) Rejected
value is highly correlated with location (ρ = 0.98687) Rejected

Variables

accuracy
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6.4135
Minimum0
Maximum10
Zeros (%)33.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median9
Q310
95-th percentile10
Maximum10
Range10
Interquartile range10

Descriptive statistics

Standard deviation4.5712
Coef of variation0.71275
Kurtosis-1.5172
Mean6.4135
MAD4.2838
Skewness-0.65808
Sum42797
Variance20.896
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
10 3202 48.0%
 
0 2210 33.1%
 
9 972 14.6%
 
8 169 < 0.1%
 
7 45 < 0.1%
 
6 45 < 0.1%
 
2 15 < 0.1%
 
4 11 < 0.1%
 
5 3 < 0.1%
 
3 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2210 33.1%
 
2 15 < 0.1%
 
3 1 < 0.1%
 
4 11 < 0.1%
 
5 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
10 3202 48.0%
 
9 972 14.6%
 
8 169 < 0.1%
 
7 45 < 0.1%
 
6 45 < 0.1%
 

amt_w_service
Numeric

Distinct count525
Unique (%)7.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean194.01
Minimum14
Maximum994
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum14
5-th percentile25
Q166
Median119
Q3248
95-th percentile655
Maximum994
Range980
Interquartile range182

Descriptive statistics

Standard deviation194.87
Coef of variation1.0044
Kurtosis2.9665
Mean194.01
MAD144.79
Skewness1.8085
Sum1.2946e+06
Variance37973
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
132 131 < 0.1%
 
105 112 < 0.1%
 
99 108 < 0.1%
 
72 91 < 0.1%
 
86 87 < 0.1%
 
171 87 < 0.1%
 
103 86 < 0.1%
 
69 86 < 0.1%
 
112 83 < 0.1%
 
82 82 < 0.1%
 
Other values (515) 5720 85.7%
 

Minimum 5 values

ValueCountFrequency (%) 
14 34 < 0.1%
 
16 28 < 0.1%
 
17 44 < 0.1%
 
18 16 < 0.1%
 
20 43 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
994 1 < 0.1%
 
986 13 < 0.1%
 
985 4 < 0.1%
 
980 1 < 0.1%
 
972 1 < 0.1%
 

avg_rating
Highly correlated

This variable is highly correlated with accuracy and should be ignored for analysis

Correlation0.99232

bathrooms
Numeric

Distinct count26
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
Infinite (%)0.0%
Infinite (n)0
Mean1.8778
Minimum0
Maximum50
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median1.5
Q32
95-th percentile4
Maximum50
Range50
Interquartile range1

Descriptive statistics

Standard deviation1.371
Coef of variation0.73014
Kurtosis245.34
Mean1.8778
MAD0.88603
Skewness8.8432
Sum12526
Variance1.8797
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
1 3247 48.7%
 
2 1563 23.4%
 
3 473 7.1%
 
2.5 408 6.1%
 
3.5 250 < 0.1%
 
1.5 228 < 0.1%
 
4 198 < 0.1%
 
4.5 119 < 0.1%
 
5 48 < 0.1%
 
5.5 40 < 0.1%
 
Other values (15) 97 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 8 < 0.1%
 
0.5 3 < 0.1%
 
1 3247 48.7%
 
1.5 228 < 0.1%
 
2 1563 23.4%
 

Maximum 5 values

ValueCountFrequency (%) 
50 1 < 0.1%
 
25 1 < 0.1%
 
15 2 < 0.1%
 
12 2 < 0.1%
 
11 1 < 0.1%
 

bedrooms
Numeric

Distinct count18
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
Infinite (%)0.0%
Infinite (n)0
Mean1.893
Minimum0
Maximum50
Zeros (%)6.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median2
Q33
95-th percentile4
Maximum50
Range50
Interquartile range2

Descriptive statistics

Standard deviation1.452
Coef of variation0.76703
Kurtosis194.63
Mean1.893
MAD0.96471
Skewness7.3582
Sum12628
Variance2.1082
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
1 2658 39.8%
 
2 1865 27.9%
 
3 1061 15.9%
 
0 446 6.7%
 
4 436 6.5%
 
5 111 < 0.1%
 
6 44 < 0.1%
 
7 16 < 0.1%
 
8 14 < 0.1%
 
10 12 < 0.1%
 
Other values (7) 8 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 446 6.7%
 
1 2658 39.8%
 
2 1865 27.9%
 
3 1061 15.9%
 
4 436 6.5%
 

Maximum 5 values

ValueCountFrequency (%) 
50 1 < 0.1%
 
25 1 < 0.1%
 
15 1 < 0.1%
 
14 1 < 0.1%
 
13 1 < 0.1%
 

can_instant_book
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
True
4851
False
1822
ValueCountFrequency (%) 
True 4851 72.7%
 
False 1822 27.3%
 

checkin
Highly correlated

This variable is highly correlated with avg_rating and should be ignored for analysis

Correlation0.98906

cleanliness
Highly correlated

This variable is highly correlated with checkin and should be ignored for analysis

Correlation0.98857

communication
Highly correlated

This variable is highly correlated with cleanliness and should be ignored for analysis

Correlation0.98852

currency
Constant

This variable is constant and should be ignored for analysis

Constant valueCAD

guest_satisfication
Highly correlated

This variable is highly correlated with communication and should be ignored for analysis

Correlation0.99219

host_id
Numeric

Distinct count3442
Unique (%)51.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.0767e+08
Minimum40057
Maximum2.7169e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum40057
5-th percentile2.3517e+06
Q13.5724e+07
Median9.69e+07
Q31.7227e+08
95-th percentile2.4591e+08
Maximum2.7169e+08
Range2.7165e+08
Interquartile range1.3654e+08

Descriptive statistics

Standard deviation7.969e+07
Coef of variation0.74011
Kurtosis-1.1021
Mean1.0767e+08
MAD6.9024e+07
Skewness0.36646
Sum7.185e+11
Variance6.3506e+15
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
1.4816e+07 57 < 0.1%
 
5.8893e+07 52 < 0.1%
 
1.1755e+08 33 < 0.1%
 
2.7622e+07 32 < 0.1%
 
9.702e+06 31 < 0.1%
 
6.4321e+07 31 < 0.1%
 
2.3783e+05 30 < 0.1%
 
1.9585e+08 28 < 0.1%
 
2.5315e+08 28 < 0.1%
 
2.372e+07 28 < 0.1%
 
Other values (3432) 6323 94.8%
 

Minimum 5 values

ValueCountFrequency (%) 
40057 2 < 0.1%
 
65989 1 < 0.1%
 
85132 1 < 0.1%
 
1.0343e+05 2 < 0.1%
 
1.1964e+05 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.7169e+08 1 < 0.1%
 
2.7163e+08 1 < 0.1%
 
2.7159e+08 1 < 0.1%
 
2.7131e+08 1 < 0.1%
 
2.713e+08 1 < 0.1%
 

host_reviews
Numeric

Distinct count418
Unique (%)6.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean185.55
Minimum0
Maximum3334
Zeros (%)12.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q14
Median33
Q3145
95-th percentile760
Maximum3334
Range3334
Interquartile range141

Descriptive statistics

Standard deviation466.25
Coef of variation2.5128
Kurtosis24.922
Mean185.55
MAD233.78
Skewness4.737
Sum1.2382e+06
Variance2.1739e+05
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
0 841 12.6%
 
1 331 < 0.1%
 
2 195 < 0.1%
 
3 192 < 0.1%
 
4 144 < 0.1%
 
6 129 < 0.1%
 
7 120 < 0.1%
 
5 116 < 0.1%
 
9 88 < 0.1%
 
8 82 < 0.1%
 
Other values (408) 4435 66.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 841 12.6%
 
1 331 < 0.1%
 
2 195 < 0.1%
 
3 192 < 0.1%
 
4 144 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3334 57 < 0.1%
 
3228 10 < 0.1%
 
2818 4 < 0.1%
 
2817 2 < 0.1%
 
2551 21 < 0.1%
 

is_business_travel_ready
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

is_fully_refundable
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
True
5164
False
1509
ValueCountFrequency (%) 
True 5164 77.4%
 
False 1509 22.6%
 

is_new_listing
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
6015
True
 
658
ValueCountFrequency (%) 
False 6015 90.1%
 
True 658 9.9%
 

is_superhost
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
4973
True
1700
ValueCountFrequency (%) 
False 4973 74.5%
 
True 1700 25.5%
 

lat
Numeric

Distinct count5712
Unique (%)85.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean21.068
Minimum20.45
Maximum21.534
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20.45
5-th percentile20.628
Q121.052
Median21.134
Q321.16
95-th percentile21.236
Maximum21.534
Range1.0834
Interquartile range0.10737

Descriptive statistics

Standard deviation0.17567
Coef of variation0.0083382
Kurtosis1.6448
Mean21.068
MAD0.12917
Skewness-1.5997
Sum1.4058e+05
Variance0.030859
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
21.26 21 < 0.1%
 
21.158 17 < 0.1%
 
21.12 11 < 0.1%
 
21.14 9 < 0.1%
 
21.185 8 < 0.1%
 
21.152 8 < 0.1%
 
21.16 7 < 0.1%
 
21.051 6 < 0.1%
 
21.131 5 < 0.1%
 
21.152 5 < 0.1%
 
Other values (5702) 6576 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
20.45 1 < 0.1%
 
20.453 1 < 0.1%
 
20.454 1 < 0.1%
 
20.456 1 < 0.1%
 
20.458 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
21.534 1 < 0.1%
 
21.529 1 < 0.1%
 
21.528 1 < 0.1%
 
21.525 1 < 0.1%
 
21.524 1 < 0.1%
 

listing_name
Categorical

Distinct count6587
Unique (%)> 99.9%
Missing (%)< 0.1%
Missing (n)7
New studio in Cancun downtown
 
6
Beautiful OCEANVIEW studio next to Forum!
 
6
¡Studio Apartment 700 yards from the Beach!
 
6
Other values (6583)
6648
(Missing)
 
7
ValueCountFrequency (%) 
New studio in Cancun downtown 6 < 0.1%
 
Beautiful OCEANVIEW studio next to Forum! 6 < 0.1%
 
¡Studio Apartment 700 yards from the Beach! 6 < 0.1%
 
Penthouse frente al mar 3 < 0.1%
 
Departamento en Cancún 3 < 0.1%
 
Club GR Solaris 3 < 0.1%
 
Comfortable apartment on 2º floor 3 < 0.1%
 
GR Caribe by Solaris 3 < 0.1%
 
Club Solaris GR Caribe 3 < 0.1%
 
Beautiful oceanfront condo 3 < 0.1%
 
Other values (6576) 6627 > 99.9%
 
(Missing) 7 < 0.1%
 
Max length118
Mean length37.017
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

lng
Numeric

Distinct count5497
Unique (%)82.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-86.839
Minimum-87.392
Maximum-86.713
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-87.392
5-th percentile-87.069
Q1-86.864
Median-86.826
Q3-86.781
95-th percentile-86.739
Maximum-86.713
Range0.67875
Interquartile range0.08261

Descriptive statistics

Standard deviation0.089203
Coef of variation-0.0010272
Kurtosis3.458
Mean-86.839
MAD0.062083
Skewness-1.6424
Sum-5.7948e+05
Variance0.0079572
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
-86.75 21 < 0.1%
 
-86.833 17 < 0.1%
 
-86.846 11 < 0.1%
 
-86.86 9 < 0.1%
 
-86.824 8 < 0.1%
 
-86.807 8 < 0.1%
 
-86.823 6 < 0.1%
 
-86.826 6 < 0.1%
 
-86.783 5 < 0.1%
 
-86.749 5 < 0.1%
 
Other values (5487) 6577 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
-87.392 1 < 0.1%
 
-87.392 1 < 0.1%
 
-87.389 1 < 0.1%
 
-87.389 1 < 0.1%
 
-87.383 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
-86.713 1 < 0.1%
 
-86.715 1 < 0.1%
 
-86.715 1 < 0.1%
 
-86.715 1 < 0.1%
 
-86.715 1 < 0.1%
 

localized_city
Categorical

Distinct count96
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Cancún
4494
Playa del Carmen
 
584
Isla Mujeres
 
531
Other values (93)
1064
ValueCountFrequency (%) 
Cancún 4494 67.3%
 
Playa del Carmen 584 8.8%
 
Isla Mujeres 531 8.0%
 
Puerto Morelos 401 6.0%
 
Alfredo V. Bonfil 90 < 0.1%
 
Cancun 72 < 0.1%
 
Quintana Roo 68 < 0.1%
 
Riviera Maya 55 < 0.1%
 
Cancún 43 < 0.1%
 
Cancun 30 < 0.1%
 
Other values (86) 305 < 0.1%
 
Max length44
Mean length8.4721
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

localized_neighborhood
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

location
Highly correlated

This variable is highly correlated with guest_satisfication and should be ignored for analysis

Correlation0.98793

monthly_price_factor
Numeric

Distinct count65
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.89186
Minimum0.3
Maximum1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.3
5-th percentile0.6
Q10.8
Median1
Q31
95-th percentile1
Maximum1
Range0.7
Interquartile range0.2

Descriptive statistics

Standard deviation0.13793
Coef of variation0.15466
Kurtosis0.80455
Mean0.89186
MAD0.11417
Skewness-1.2075
Sum5951.4
Variance0.019025
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
1 3380 50.7%
 
0.8 626 9.4%
 
0.9 554 8.3%
 
0.85 507 7.6%
 
0.7 316 < 0.1%
 
0.75 277 < 0.1%
 
0.95 125 < 0.1%
 
0.6 120 < 0.1%
 
0.65 105 < 0.1%
 
0.51 78 < 0.1%
 
Other values (55) 585 8.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0.3 4 < 0.1%
 
0.33 1 < 0.1%
 
0.34 1 < 0.1%
 
0.35 3 < 0.1%
 
0.37 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1 3380 50.7%
 
0.99 4 < 0.1%
 
0.98 4 < 0.1%
 
0.97 7 < 0.1%
 
0.96 2 < 0.1%
 

num_beds
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.7775
Minimum0
Maximum9
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median2
Q34
95-th percentile6
Maximum9
Range9
Interquartile range3

Descriptive statistics

Standard deviation1.7192
Coef of variation0.61899
Kurtosis0.92203
Mean2.7775
MAD1.3727
Skewness1.0802
Sum18534
Variance2.9557
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
1 1771 26.5%
 
2 1760 26.4%
 
3 1217 18.2%
 
4 864 12.9%
 
5 510 7.6%
 
6 279 < 0.1%
 
7 120 < 0.1%
 
8 89 < 0.1%
 
9 40 < 0.1%
 
0 23 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 23 < 0.1%
 
1 1771 26.5%
 
2 1760 26.4%
 
3 1217 18.2%
 
4 864 12.9%
 

Maximum 5 values

ValueCountFrequency (%) 
9 40 < 0.1%
 
8 89 < 0.1%
 
7 120 < 0.1%
 
6 279 < 0.1%
 
5 510 7.6%
 

person_capacity
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5.2375
Minimum1
Maximum16
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q13
Median4
Q36
95-th percentile10
Maximum16
Range15
Interquartile range3

Descriptive statistics

Standard deviation2.9733
Coef of variation0.56769
Kurtosis2.1097
Mean5.2375
MAD2.2816
Skewness1.3071
Sum34950
Variance8.8406
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
4 1558 23.3%
 
2 1425 21.4%
 
6 1234 18.5%
 
8 675 10.1%
 
5 486 7.3%
 
3 376 5.6%
 
10 275 < 0.1%
 
7 206 < 0.1%
 
12 122 < 0.1%
 
16 112 < 0.1%
 
Other values (6) 204 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 27 < 0.1%
 
2 1425 21.4%
 
3 376 5.6%
 
4 1558 23.3%
 
5 486 7.3%
 

Maximum 5 values

ValueCountFrequency (%) 
16 112 < 0.1%
 
15 26 < 0.1%
 
14 36 < 0.1%
 
13 16 < 0.1%
 
12 122 < 0.1%
 

picture_count
Numeric

Distinct count119
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean24.542
Minimum1
Maximum182
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile6
Q113
Median21
Q331
95-th percentile55
Maximum182
Range181
Interquartile range18

Descriptive statistics

Standard deviation16.228
Coef of variation0.66124
Kurtosis7.4591
Mean24.542
MAD11.889
Skewness1.9315
Sum1.6377e+05
Variance263.35
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
17 255 < 0.1%
 
13 243 < 0.1%
 
9 222 < 0.1%
 
18 221 < 0.1%
 
20 220 < 0.1%
 
15 217 < 0.1%
 
12 212 < 0.1%
 
23 212 < 0.1%
 
19 207 < 0.1%
 
16 203 < 0.1%
 
Other values (109) 4461 66.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 33 < 0.1%
 
2 22 < 0.1%
 
3 35 < 0.1%
 
4 63 < 0.1%
 
5 89 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
182 1 < 0.1%
 
167 1 < 0.1%
 
156 1 < 0.1%
 
155 1 < 0.1%
 
148 1 < 0.1%
 

price
Highly correlated

This variable is highly correlated with amt_w_service and should be ignored for analysis

Correlation1

rate_type
Constant

This variable is constant and should be ignored for analysis

Constant valuenightly

response_rate
Numeric

Distinct count43
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean76.997
Minimum0
Maximum100
Zeros (%)19.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q180
Median100
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range20

Descriptive statistics

Standard deviation39.621
Coef of variation0.51458
Kurtosis-0.068131
Mean76.997
MAD32.489
Skewness-1.3458
Sum5.138e+05
Variance1569.8
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
100 4178 62.6%
 
0 1328 19.9%
 
90 167 < 0.1%
 
98 133 < 0.1%
 
50 90 < 0.1%
 
80 79 < 0.1%
 
97 66 < 0.1%
 
93 64 < 0.1%
 
94 55 < 0.1%
 
74 51 < 0.1%
 
Other values (33) 462 6.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1328 19.9%
 
10 1 < 0.1%
 
20 4 < 0.1%
 
25 7 < 0.1%
 
29 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 4178 62.6%
 
99 27 < 0.1%
 
98 133 < 0.1%
 
97 66 < 0.1%
 
96 22 < 0.1%
 

response_time
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)18.2%
Missing (n)1217
within an hour
4063
within a few hours
 
692
within a day
 
540
(Missing)
1217
ValueCountFrequency (%) 
within an hour 4063 60.9%
 
within a few hours 692 10.4%
 
within a day 540 8.1%
 
a few days or more 161 < 0.1%
 
(Missing) 1217 18.2%
 
Max length18
Mean length12.343
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

reviews_count
Numeric

Distinct count231
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean20.124
Minimum0
Maximum581
Zeros (%)31.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median4
Q322
95-th percentile96
Maximum581
Range581
Interquartile range22

Descriptive statistics

Standard deviation40.221
Coef of variation1.9987
Kurtosis31.471
Mean20.124
MAD24.278
Skewness4.4189
Sum1.3428e+05
Variance1617.8
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
0 2089 31.3%
 
1 602 9.0%
 
2 351 5.3%
 
3 291 < 0.1%
 
4 197 < 0.1%
 
5 162 < 0.1%
 
6 159 < 0.1%
 
7 113 < 0.1%
 
8 102 < 0.1%
 
9 98 < 0.1%
 
Other values (221) 2509 37.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2089 31.3%
 
1 602 9.0%
 
2 351 5.3%
 
3 291 < 0.1%
 
4 197 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
581 1 < 0.1%
 
537 1 < 0.1%
 
482 1 < 0.1%
 
481 1 < 0.1%
 
475 1 < 0.1%
 

room_type_category
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
entire_home
5013
private_room
1641
shared_room
 
19
ValueCountFrequency (%) 
entire_home 5013 75.1%
 
private_room 1641 24.6%
 
shared_room 19 < 0.1%
 
Max length12
Mean length11.246
Min length11
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

star_rating
Highly correlated

This variable is highly correlated with guest_satisfication and should be ignored for analysis

Correlation0.91733

url
URL

Distinct count6673
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
ValueCountFrequency (%) 
https://www.airbnb.com/rooms/18758185 1 < 0.1%
 
https://www.airbnb.com/rooms/35686080 1 < 0.1%
 
https://www.airbnb.com/rooms/33655772 1 < 0.1%
 
https://www.airbnb.com/rooms/32168685 1 < 0.1%
 
https://www.airbnb.com/rooms/31615807 1 < 0.1%
 
https://www.airbnb.com/rooms/34463515 1 < 0.1%
 
https://www.airbnb.com/rooms/21096786 1 < 0.1%
 
https://www.airbnb.com/rooms/23649627 1 < 0.1%
 
https://www.airbnb.com/rooms/12191587 1 < 0.1%
 
https://www.airbnb.com/rooms/11300329 1 < 0.1%
 
Other values (6663) 6663 > 99.9%
 
ValueCountFrequency (%) 
https 6673 100.0%
 
ValueCountFrequency (%) 
www.airbnb.com 6673 100.0%
 
ValueCountFrequency (%) 
/rooms/19500867 1 < 0.1%
 
/rooms/32957158 1 < 0.1%
 
/rooms/33334004 1 < 0.1%
 
/rooms/21891360 1 < 0.1%
 
/rooms/14930294 1 < 0.1%
 
/rooms/32839147 1 < 0.1%
 
/rooms/23433141 1 < 0.1%
 
/rooms/35804675 1 < 0.1%
 
/rooms/34084587 1 < 0.1%
 
/rooms/27306201 1 < 0.1%
 
Other values (6663) 6663 > 99.9%
 
ValueCountFrequency (%) 
6673 100.0%
 
ValueCountFrequency (%) 
6673 100.0%
 

value
Highly correlated

This variable is highly correlated with location and should be ignored for analysis

Correlation0.98687

weekly_price_factor
Numeric

Distinct count41
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.95204
Minimum0.43
Maximum1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.43
5-th percentile0.81
Q10.9
Median1
Q31
95-th percentile1
Maximum1
Range0.57
Interquartile range0.1

Descriptive statistics

Standard deviation0.063889
Coef of variation0.067107
Kurtosis2.2412
Mean0.95204
MAD0.052484
Skewness-1.3899
Sum6352.9
Variance0.0040817
Memory size52.2 KiB
Histogram
ValueCountFrequency (%) 
1 3596 53.9%
 
0.9 1153 17.3%
 
0.95 764 11.4%
 
0.85 329 < 0.1%
 
0.79 146 < 0.1%
 
0.8 111 < 0.1%
 
0.92 74 < 0.1%
 
0.97 67 < 0.1%
 
0.88 57 < 0.1%
 
0.93 52 < 0.1%
 
Other values (31) 324 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0.43 1 < 0.1%
 
0.5 1 < 0.1%
 
0.6 1 < 0.1%
 
0.62 2 < 0.1%
 
0.63 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1 3596 53.9%
 
0.99964 1 < 0.1%
 
0.99 16 < 0.1%
 
0.98 23 < 0.1%
 
0.97 67 < 0.1%
 

Correlations

Pearson matrix
Spearman matrix
Kendall matrix
Phi<sub>k</sub> matrix
Recoded matrix

Missing values

Matrix

Matrix

Count

Bar

Heatmap

Heatmap

Dendrogram

Dendrogram

Sample

First rows

accuracyamt_w_serviceavg_ratingbathroomsbedroomscan_instant_bookcheckincleanlinesscommunicationcurrencyguest_satisficationhost_idhost_reviewsis_business_travel_readyis_fully_refundableis_new_listingis_superhostlatlisting_namelnglocalized_citylocalized_neighborhoodlocationmonthly_price_factornum_bedsperson_capacitypicture_countpricerate_typeresponse_rateresponse_timereviews_countroom_type_categorystar_ratingurlvalueweekly_price_factor
010224.741.01.0True10910CAD9543548195311FalseTrueFalseTrue21.135660C1 ✪ Renovado Mini Room A/C laguna y mar-86.767410CancúnNaN100.88121922nightly100within an hour50private_room5.0https://www.airbnb.com/rooms/20776319100.88
110284.931.01.0False101010CAD9994835591147FalseTrueFalseTrue21.145710Habitación privada en la mejor ubicación, albe...-86.841900CancúnNaN100.85122228nightly100within a few hours108private_room5.0https://www.airbnb.com/rooms/16492050100.90
210304.721.51.0True10910CAD94851873881376FalseTrueFalseFalse21.131190BEST LOCATION IN HOTEL ZONE, SECURE AND COZY!-86.763940CancúnNaN91.00121430nightly100within an hour243private_room4.5https://www.airbnb.com/rooms/1426645191.00
310244.751.02.0True10910CAD9591309199179FalseTrueFalseTrue21.157370Aparment for all the family in Cancun´s downtown-86.839750CancúnNaN100.79252724nightly97within an hour177entire_home5.0https://www.airbnb.com/rooms/17625889100.93
410214.651.01.0True10910CAD93128623591631FalseTrueFalseFalse21.153270PRIVATE ROOM. A / C. BREAKFAST. PRIVATE ACCESS-86.855480CancúnNaN90.80231821nightly100within an hour194entire_home4.5https://www.airbnb.com/rooms/1854314790.95
510294.841.01.0True101010CAD97117373947521FalseTrueFalseTrue21.165480Mi CaSiTa DoS-86.831240CancúnNaN101.00121829nightly100within an hour196entire_home5.0https://www.airbnb.com/rooms/21853372101.00
610294.911.01.0False101010CAD98260748351735FalseTrueFalseTrue21.154510Charming private room away from tourist area ☆...-86.822830CancúnNaN101.00122529nightly100within an hour324private_room5.0https://www.airbnb.com/rooms/8798839100.90
710284.951.01.0True101010CAD9915516850864FalseTrueFalseTrue21.184435Tropical Experience Cancun-Cozy Room Cancun City-86.830498CancúnNaN91.00132228nightly100within an hour63private_room5.0https://www.airbnb.com/rooms/21413573101.00
810244.681.01.0True91010CAD9410831142176FalseTrueFalseFalse21.148240Casa Lava-86.827240CancúnNaN90.90121324nightly95within an hour171private_room4.5https://www.airbnb.com/rooms/20122417100.95
910254.701.01.0True10910CAD94126301804213FalseTrueFalseFalse21.157590RECÁMARA ANONA CANCÚN a 7 min de ZONA HOTELERA-86.832950CancúnNaN101.00122425nightly97within an hour118entire_home4.5https://www.airbnb.com/rooms/23809351101.00

Last rows

accuracyamt_w_serviceavg_ratingbathroomsbedroomscan_instant_bookcheckincleanlinesscommunicationcurrencyguest_satisficationhost_idhost_reviewsis_business_travel_readyis_fully_refundableis_new_listingis_superhostlatlisting_namelnglocalized_citylocalized_neighborhoodlocationmonthly_price_factornum_bedsperson_capacitypicture_countpricerate_typeresponse_rateresponse_timereviews_countroom_type_categorystar_ratingurlvalueweekly_price_factor
666306550.002.02.0False000CAD02406734650FalseFalseFalseFalse20.764730Suite con Dos Recámaras de Mayan Palace-86.954420Riviera MayaNaN01.04815655nightly100within a day0entire_homeNaNhttps://www.airbnb.com/rooms/3228355501.00
666406550.001.01.0True000CAD01763437040FalseFalseFalseFalse20.729070Grand Bliss in Vidanta Resort, Mayan Riviera-87.004350Playa del CarmenNaN01.0165655nightly100within a few hours0entire_homeNaNhttps://www.airbnb.com/rooms/2858333401.00
6665106555.003.03.0False101010CAD10016265252398FalseFalseFalseTrue20.614038Beautiful Villa with amazing private pool.-87.081673Playa del CarmenNaN100.85840655nightly100within an hour8entire_home5.0https://www.airbnb.com/rooms/27092203100.90
6666106554.833.03.0True101010CAD977834934238FalseFalseFalseFalse20.616230Casa Moskito, Oceanfront, Beautiful New Villa-87.078540Playa del CarmenNaN100.94838655nightly100within an hour30entire_home5.0https://www.airbnb.com/rooms/13590317100.95
6667106555.002.02.0False101010CAD100969000822FalseFalseFalseFalse20.633180Luxury Caribbean Condo-87.067840Playa del CarmenNaN101.03616655nightly0NaN1entire_homeNaNhttps://www.airbnb.com/rooms/15240869100.90
666897214.605.54.0True1099CAD9215583654711FalseFalseFalseFalse21.116180MARALAGO HOUSE-86.766440CancúnNaN91.04818721nightly0NaN5entire_home4.5https://www.airbnb.com/rooms/2157918491.00
666907440.003.53.0True000CAD01958484840FalseFalseFalseFalse20.632350*NO GUEST SERVICE FEE* Magic - 3 Bedrooms Pent...-87.065840Playa del CarmenNaN01.051050744nightly100within an hour0entire_homeNaNhttps://www.airbnb.com/rooms/2617085301.00
6670107815.003.03.0True101010CAD10019342611610FalseFalseFalseFalse21.518520Casa Mariposa (Tulip) In Holbox-87.389390Isla HolboxNaN101.05818781nightly100within an hour2entire_homeNaNhttps://www.airbnb.com/rooms/31122862101.00
667198535.004.54.0False9109CAD10015492891296FalseFalseFalseFalse20.927374Paradise Villa-86.842155Puerto MorelosNaN90.971036853nightly100within an hour4entire_home5.0https://www.airbnb.com/rooms/343114390.95
667209940.002.03.0False000CAD0154160247FalseFalseFalseTrue20.6268603 Bedroom/2 Bath Luxury Oceanside Penthouse-87.071060Playa del CarmenNaN01.04618994nightly100within a day0entire_homeNaNhttps://www.airbnb.com/rooms/1369487700.90